package com.service;

import com.bean.Message;

import java.sql.SQLException;
import java.util.List;

public interface MessageService {


     List<Message> selectAll() throws SQLException ;

     List<Message>  selectByName(String userName) throws SQLException ;

     boolean deleteById(Integer id) throws SQLException ;

     boolean insert(Message b) throws SQLException;

     Integer count() throws SQLException ;

     Integer countSearch(String search) throws SQLException ;


     List<Message> selectAllPagination(Integer offset, Integer limit) throws SQLException ;

     List<Message> selectAllPaginationSearch(Integer offset, Integer limit, String search) throws SQLException ;

}
